www.gusucode.com > WSTMall PHP网店系统 v1.6.0PHP源码程序 > WSTMall PHP网店系统 v1.6.0/wstmall_v1.6.0_160506/wstmall_v1.6.0_160506/Apps/Home/Model/ArticlesModel.class.php
<?php namespace Home\Model; /** * ============================================================================ * WSTMall开源商城 * 官网地址:http://www.wstmall.com * 联系QQ:707563272 * ============================================================================ * 文章服务类 */ class ArticlesModel extends BaseModel { /** * 获取文章列表 */ public function getArticleList(){ $articleList = S("WST_CACHE_ARTICLE_LIST"); if(!$articleList){ $sql ="SELECT artcat.catName, art.articleId,art.catId,art.articleTitle,art.articleImg FROM __PREFIX__article_cats artcat,__PREFIX__articles art WHERE artcat.catId = art.catId AND artcat.catType=1 AND artcat.catFlag = 1 AND artcat.isShow=1 AND art.isShow=1 ORDER BY artcat.catSort ,art.articleId"; $rs = $this->query($sql); $articles = array(); for ($i=0;$i<count($rs);$i++){ $articleList[$rs[$i]["catId"]]["articlecats"][] = $rs[$i]; $articleList[$rs[$i]["catId"]]["catName"] = $rs[$i]["catName"]; } S("WST_CACHE_ARTICLE_LIST",$articleList,2592000); } return $articleList; } /** * 获取文章详情 */ public function getArticle($obj){ $articleId = (int)$obj["articleId"]; $sql ="SELECT * FROM __PREFIX__articles WHERE articleId=$articleId AND isShow=1 "; $article = $this->queryRow($sql); return $article; } /** * 查询网站帮助 */ public function getHelps(){ $articles = S("WST_CACHE_ARTICLE_INDEX"); if(!$articles){ $sql ="SELECT artcat.catName, art.articleId,art.catId,art.articleTitle,art.articleImg FROM __PREFIX__article_cats artcat,__PREFIX__articles art WHERE artcat.catId = art.catId AND artcat.catType=1 AND artcat.catFlag = 1 AND artcat.isShow=1 AND art.isShow=1 ORDER BY artcat.catSort ,art.articleId"; $rs = $this->query($sql); $articles = array(); for ($i=0;$i<count($rs);$i++){ $articles[$rs[$i]["catId"]]["articlecats"][] = $rs[$i]; $articles[$rs[$i]["catId"]]["catName"] = $rs[$i]["catName"]; } S("WST_CACHE_ARTICLE_INDEX",$articles,2592000); } return $articles; } }